---
title: DB-CLL-065-104 — Standard reference-data CRUD across 8 TableMaint objects
summary: Standard reference-data CRUD across 8 TableMaint objects
status: draft
owner: SAIF Case Management team
last_reviewed: 2026-08-21
library: SAIF.Business.Claim.Legal
reference_type: embedded
---

# DB-CLL-065-104 — Standard reference-data CRUD across 8 TableMaint objects

## Classification

| Field | Value |
|---|---|
| SQL ID | DB-CLL-065-104 |
| Operation type | R,I,U,D |
| Execution method | Text |
| Database | Oracle (Case Management) |
| Schema | [unqualified]** |
| Command type | Inline text SQL |
| Business object | clsAttorneyConflict, clsAttorneyWorkerAssignment (+ clsAttorneyPolicyAssignment, clsAttorneySchedule), clsLegalPersonType, clsOtherFirm, clsOutOFTownRotationAssgn, clsHearingLocation |
| Criteria property | CreateSQL/RetrieveSQL/InsertSQL/UpdateSQL/DeleteSQL |
| Lifecycle method | AfterCreate/AfterRetrieve/BeforeInsert/BeforeUpdate/BeforeDelete |

## Parameters

No bound parameters were identified for this statement.

## Tables

| Table | Access | Columns/Notes |
|---|---|---|
| [ATTORNEY_CONFLICT](../database-tables.md#attorney_conflict) | CRUD | full column set |
| [ATTORNEY_POLICY_ASSIGNMENT](../database-tables.md#attorney_policy_assignment) | CRUD | full column set |
| [ATTORNEY_SCHEDULE](../database-tables.md#attorney_schedule) | CRUD | full column set |
| [ATTORNEY_WORKER_ASSIGNMENT](../database-tables.md#attorney_worker_assignment) | CRUD | full column set |
| [LEGAL_PERSON_TYPE](../database-tables.md#legal_person_type) | CRUD | full column set |
| [OTHER_FIRM](../database-tables.md#other_firm) | CRUD | full column set |
| [OUT_OF_TOWN_ROTATION_ASSGN](../database-tables.md#out_of_town_rotation_assgn) | CRUD | full column set |
| [HEARING_LOCATION](../database-tables.md#hearing_location) | CRUD | full column set |

## Sample SQL

```sql
-- Representative pattern: clsAttorneyConflict RetrieveSQL (one of 8 TableMaint reference
-- objects in this consolidated group), reconstructed verbatim from
-- SAIF.Business.Claim.Legal\TableMaint\clsAttorneyConflict.vb:
Select
  ATTORNEY_CONFLICT.ATTORNEY_CONFLICT_SEQ_NUM as AttorneyConflictSeqNum,
  ATTORNEY_CONFLICT.ATTORNEY_EMPLID as AttorneyEmplid,
  ATTORNEY_CONFLICT.EFF_DATE as EffDate,
  ATTORNEY_CONFLICT.EXP_DATE as ExpDate,
  to_char(ATTORNEY_CONFLICT.CONFLICT_LEGAL_PERSON_SEQ_NUM) as ConflictLegalPersonSeqNum,
  to_char(ATTORNEY_CONFLICT.ATTY_PROVIDER_LOCATION_SEQ_NUM) as ProviderLocationID,
  ATTORNEY_CONFLICT.ADJUSTER_EMPLID as AdjusterEmplid,
  ATTORNEY_CONFLICT.POLICY_NUM as PolicyNum
From
  ATTORNEY_CONFLICT
Where
  ATTORNEY_CONFLICT.ATTORNEY_CONFLICT_SEQ_NUM = :AttorneyConflictSeqNum

-- plus matching Insert/Update/Delete statements and a Create-sequence Select per object.
-- Each of the other 7 TableMaint objects listed above repeats this same CRUD shape against
-- its own table (see database-tables.md for the per-table column detail); the exact column
-- lists for those other 7 objects were **not individually reconstructed here — consolidated
-- to avoid ~40 near-duplicate single-purpose pages, per the DB analysis's own consolidation
-- approach. Treat the non-clsAttorneyConflict statements as unverified until inspected
-- directly against their respective .vb source files.
```

## Operations and processes

- [Manage hearing locations](../operations/manage-hearing-location.md)
- [Manage attorney and legal-person reference data](../operations/manage-attorney-and-legal-person.md)

## Business rules

- [BR-CLM-LGL-006](../business-rules.md#br-clm-lgl-006-attorney-policy-assignment-requires-a-valid-policy)
- [BR-CLM-LGL-007](../business-rules.md#br-clm-lgl-007-attorney-policy-assignment-requires-a-primary-attorney)
- [BR-CLM-LGL-008](../business-rules.md#br-clm-lgl-008-attorney-profile-requires-attorney%2C-type%2C-and-valid-date-range)
- [BR-CLM-LGL-009](../business-rules.md#br-clm-lgl-009-duplicate-attorney-profile-rows-are-rejected)
- [BR-CLM-LGL-010](../business-rules.md#br-clm-lgl-010-attorney-schedule-entry-requires-attorney%2C-reason%2C-and-duration)
- [BR-CLM-LGL-011](../business-rules.md#br-clm-lgl-011-attorney-schedule-dates-must-be-valid-and-non-past)
- [BR-CLM-LGL-012](../business-rules.md#br-clm-lgl-012-hearing-location-requires-valid-code%2C-name%2C-state%2C-and-city)
- [BR-CLM-LGL-013](../business-rules.md#br-clm-lgl-013-hearing-location-cannot-be-deleted-while-referenced-by-schedule-rows)
- [BR-CLM-LGL-014](../business-rules.md#br-clm-lgl-014-legal-person-requires-last-and-first-name)
- [BR-CLM-LGL-015](../business-rules.md#br-clm-lgl-015-legal-person-cannot-be-deleted-while-referenced)
- [BR-CLM-LGL-016](../business-rules.md#br-clm-lgl-016-legal-person-type-link-requires-person-and-type-code)
- [BR-CLM-LGL-017](../business-rules.md#br-clm-lgl-017-other-firm-state-city-must-be-valid)
- [BR-CLM-LGL-018](../business-rules.md#br-clm-lgl-018-out-of-town-rotation-assignment-dates-must-be-valid-and-non-past)

## Sources

- `SAIF.Business.Claim.Legal\TableMaint\ (clsAttorneyConflict.vb, clsAttorneyWorkerAssignment.vb, clsLegalPersonType.vb, clsOtherFirm.vb, clsOutOFTownRotationAssgn.vb, clsHearingLocation.vb)`